How to: Add new data to an existing chart.
Solution:
Copy the data to be added and paste it into the chart.
NOTE: The following procedure assumes that the chart sheet and the worksheet are in the same workbook, and the workbook is open.
1) Select the data to be added to the chart.
2) Select the 'Edit' menu and select 'Copy'.
3) Select the tab for the chart sheet into which the data is to be added.
4) Select the 'Edit' menu and select 'Paste'.